---------------- loai tai khoan-----------------
---------- thong tin
if exists (select name from sysobjects where name like 'Proc_LoaiThe_GetById')
	drop procedure Proc_LoaiThe_GetById
go

create PROC Proc_LoaiThe_GetById (@maLoai int )
as
	select * from LoaiThe
	where MaLoai = @maLoai
go

Exec Proc_LoaiThe_GetById 1
go

---------------- -----------------------------
-------- thongtin thong qua maloaiky han----------------
---------- thong tin khach hang
if exists (select name from sysobjects where name like 'Proc_LoaiThe_GetByMaLoaiTK')
	drop procedure Proc_LoaiThe_GetByMaLoaiTK
go

create PROC Proc_LoaiThe_GetBymaLoaiTK(@maLoaiTK int )
as
	select * from LoaiThe
	where maLoaiTK= @maLoaiTK
go

Exec Proc_LoaiThe_GetBymaLoaiTK 5
go

